/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50626
 Source Host           : localhost
 Source Database       : deployer

 Target Server Type    : MySQL
 Target Server Version : 50626
 File Encoding         : utf-8

 Date: 01/20/2016 15:58:50 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `access`
-- ----------------------------
DROP TABLE IF EXISTS `access`;
CREATE TABLE `access` (
  `id` int(11) NOT NULL,
  `rid` int(6) NOT NULL,
  `nid` smallint(6) unsigned NOT NULL,
  `pid` smallint(6) NOT NULL,
  `fields` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `access`
-- ----------------------------
BEGIN;
INSERT INTO `access` VALUES ('14330', '0', '1176', '0', null), ('14329', '0', '1187', '1176', null), ('14328', '0', '1184', '1176', null), ('14327', '0', '1183', '1176', null), ('14326', '0', '1181', '1176', null), ('14325', '0', '1177', '1176', null), ('14324', '0', '1176', '0', null), ('14323', '0', '1174', '0', null), ('14322', '0', '1172', '0', null), ('14321', '0', '1170', '0', null), ('14320', '0', '1009', '0', null), ('14319', '0', '1162', '0', null), ('14318', '0', '1187', '1176', null), ('14317', '0', '1184', '1176', null), ('14316', '0', '1183', '1176', null), ('14315', '0', '1181', '1176', null), ('14314', '0', '1177', '1176', null), ('14313', '0', '1182', '1174', null), ('14312', '0', '1175', '1174', null), ('14311', '0', '1173', '1172', null), ('14310', '0', '1186', '1170', null), ('14309', '0', '1185', '1170', null), ('14308', '0', '1179', '1170', null), ('14307', '0', '1171', '1170', null), ('14306', '0', '1091', '1009', null), ('14305', '0', '1090', '1009', null), ('14304', '0', '1089', '1009', null), ('14303', '0', '1087', '1009', null), ('14302', '0', '1076', '1009', null), ('14301', '0', '1074', '1009', null), ('14300', '0', '1073', '1009', null), ('14299', '0', '1072', '1009', null), ('14298', '0', '1060', '1009', null), ('14297', '0', '1058', '1009', null), ('14296', '0', '1057', '1009', null), ('14295', '0', '1056', '1009', null), ('14294', '0', '1054', '1009', null), ('14293', '0', '1004', '1009', null), ('14292', '0', '1003', '1009', null), ('14291', '0', '1002', '1009', null), ('14290', '0', '1169', '1162', null), ('14289', '0', '1164', '1162', null), ('14288', '0', '1163', '1162', null), ('16477', '-300', '1215', '0', null), ('17782', '-500', '1236', '0', null), ('17781', '-500', '1232', '0', null), ('17780', '-500', '1084', '0', null), ('17779', '-500', '1010', '0', null), ('17778', '-500', '1009', '0', null), ('17777', '-500', '1247', '1246', null), ('17776', '-500', '1244', '1246', null), ('17775', '-500', '1233', '1246', null), ('17774', '-500', '1245', '1236', null), ('17773', '-500', '1243', '1236', null), ('17772', '-500', '1237', '1236', null), ('17771', '-500', '1235', '1236', null), ('17770', '-500', '1231', '1236', null), ('17769', '-500', '1242', '1232', null), ('17768', '-500', '1241', '1232', null), ('17767', '-500', '1240', '1232', null), ('17766', '-500', '1239', '1232', null), ('17765', '-500', '1238', '1232', null), ('17764', '-500', '1086', '1084', null), ('17763', '-500', '1085', '1084', null), ('17762', '-500', '1017', '1010', null), ('16514', '-200', '1215', '0', null), ('16476', '-300', '1226', '0', null), ('16475', '-300', '1228', '0', null), ('16474', '-300', '1229', '0', null), ('16473', '-300', '1084', '0', null), ('16472', '-300', '1211', '0', null), ('16471', '-300', '1010', '0', null), ('16470', '-300', '1217', '1215', null), ('16469', '-300', '1227', '1215', null), ('16468', '-300', '1225', '1226', null), ('16467', '-300', '1213', '1228', null), ('16466', '-300', '1230', '1229', null), ('16465', '-300', '1086', '1084', null), ('17783', '-500', '1246', '0', null), ('17745', '-400', '1246', '0', null), ('17744', '-400', '1236', '0', null), ('17743', '-400', '1084', '0', null), ('17761', '-500', '1091', '1009', null), ('17760', '-500', '1090', '1009', null), ('17759', '-500', '1089', '1009', null), ('17758', '-500', '1087', '1009', null), ('17757', '-500', '1076', '1009', null), ('17742', '-400', '1010', '0', null), ('17741', '-400', '1244', '1246', null), ('17740', '-400', '1245', '1236', null), ('17739', '-400', '1243', '1236', null), ('17738', '-400', '1237', '1236', null), ('17737', '-400', '1235', '1236', null), ('17736', '-400', '1231', '1236', null), ('17735', '-400', '1086', '1084', null), ('17734', '-400', '1085', '1084', null), ('17733', '-400', '1017', '1010', null), ('17756', '-500', '1074', '1009', null), ('17755', '-500', '1073', '1009', null), ('17754', '-500', '1072', '1009', null), ('16513', '-200', '1226', '0', null), ('16512', '-200', '1228', '0', null), ('16511', '-200', '1084', '0', null), ('16510', '-200', '1010', '0', null), ('16509', '-200', '1217', '1215', null), ('16508', '-200', '1225', '1226', null), ('16507', '-200', '1218', '1228', null), ('16506', '-200', '1219', '1228', null), ('16505', '-200', '1224', '1228', null), ('16504', '-200', '1220', '1228', null), ('16503', '-200', '1213', '1228', null), ('16502', '-200', '1086', '1084', null), ('16501', '-200', '1085', '1084', null), ('16500', '-200', '1017', '1010', null), ('14812', '-100', '1017', '1010', null), ('14813', '-100', '1085', '1084', null), ('14814', '-100', '1086', '1084', null), ('14815', '-100', '1171', '1170', null), ('14816', '-100', '1179', '1170', null), ('14817', '-100', '1185', '1170', null), ('14818', '-100', '1186', '1170', null), ('14819', '-100', '1173', '1172', null), ('14820', '-100', '1201', '1172', null), ('14821', '-100', '1199', '1176', null), ('14822', '-100', '1177', '1176', null), ('14823', '-100', '1183', '1176', null), ('14824', '-100', '1191', '1176', null), ('14825', '-100', '1187', '1176', null), ('14826', '-100', '1200', '1197', null), ('14827', '-100', '1198', '1197', null), ('14828', '-100', '1010', '0', null), ('14829', '-100', '1084', '0', null), ('14830', '-100', '1170', '0', null), ('14831', '-100', '1172', '0', null), ('14832', '-100', '1176', '0', null), ('14833', '-100', '1197', '0', null), ('16464', '-300', '1085', '1084', null), ('16463', '-300', '1218', '1211', null), ('16462', '-300', '1219', '1211', null), ('16461', '-300', '1224', '1211', null), ('16460', '-300', '1222', '1211', null), ('16459', '-300', '1220', '1211', null), ('17753', '-500', '1060', '1009', null), ('17752', '-500', '1058', '1009', null), ('17751', '-500', '1057', '1009', null), ('17750', '-500', '1056', '1009', null), ('17749', '-500', '1054', '1009', null), ('17748', '-500', '1004', '1009', null), ('17747', '-500', '1003', '1009', null), ('17746', '-500', '1002', '1009', null), ('16458', '-300', '1221', '1211', null), ('16457', '-300', '1214', '1211', null), ('16456', '-300', '1212', '1211', null), ('16455', '-300', '1017', '1010', null);
COMMIT;

-- ----------------------------
--  Table structure for `adminuser`
-- ----------------------------
DROP TABLE IF EXISTS `adminuser`;
CREATE TABLE `adminuser` (
  `id` int(11) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  `ename` varchar(30) DEFAULT NULL,
  `email` varchar(50) NOT NULL,
  `depart` varchar(20) DEFAULT NULL,
  `position` varchar(20) DEFAULT NULL,
  `role` varchar(20) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `passwd` char(32) NOT NULL,
  `salt` char(5) NOT NULL COMMENT '随机',
  `rid` int(11) NOT NULL COMMENT '权限角色',
  `remark` varchar(250) NOT NULL,
  `wid` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `adminuser`
-- ----------------------------
BEGIN;
INSERT INTO `adminuser` VALUES ('1033', '汤青松', '', 'tangqingsong@wanglibank.com', '', '', '超级管理员', '1', '5d63145bbc0e4fed1529b78c88b6c922', 'Ih61B', '-500', '', '19,18');
COMMIT;

-- ----------------------------
--  Table structure for `dbcache`
-- ----------------------------
DROP TABLE IF EXISTS `dbcache`;
CREATE TABLE `dbcache` (
  `skey` char(32) NOT NULL,
  `value` varchar(5000) DEFAULT NULL,
  `expiry` int(32) NOT NULL,
  PRIMARY KEY (`skey`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
--  Records of `dbcache`
-- ----------------------------
BEGIN;
INSERT INTO `dbcache` VALUES ('bdb106a0560c4e46ccc488ef010af787', 's:32:\"057922a6145d54d101c477f35b9d9ec4\";', '1447383216'), ('03e0704b5690a2dee1861dc3ad3316c9', 's:32:\"2459bb18659edeb9969f2d5f3d2e3f92\";', '1445326893'), ('e17184bcb70dcf3942c54e0b537ffc6d', 's:32:\"0e580526ffa77ecb8e1bfdbc3328cbf1\";', '1453359072');
COMMIT;

-- ----------------------------
--  Table structure for `id_genter`
-- ----------------------------
DROP TABLE IF EXISTS `id_genter`;
CREATE TABLE `id_genter` (
  `obj` varchar(32) NOT NULL DEFAULT '',
  `id` int(11) NOT NULL DEFAULT '1',
  `step` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`obj`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `id_genter`
-- ----------------------------
BEGIN;
INSERT INTO `id_genter` VALUES ('access', '17783', '1'), ('adminuser', '1035', '1'), ('blog', '250', '1'), ('calllog', '20', '1'), ('introduction', '1075662', '1'), ('inventment', '10893', '1'), ('lib', '40', '1'), ('liblog', '447', '1'), ('loginlog', '1726', '1'), ('node', '1247', '1'), ('operationlog', '1454', '1'), ('recharge', '17132', '1'), ('role', '1033', '1'), ('server', '25', '1'), ('servergroup', '23', '1'), ('SN2015', '1147', '1'), ('sysinfo', '21930', '1'), ('task', '8656', '1'), ('upload', '4567', '1'), ('user', '7463', '1'), ('useradmin', '183', '1'), ('website', '21', '1');
COMMIT;

-- ----------------------------
--  Table structure for `lib`
-- ----------------------------
DROP TABLE IF EXISTS `lib`;
CREATE TABLE `lib` (
  `id` int(10) unsigned NOT NULL,
  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `utime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `path` text,
  `version` varchar(30) DEFAULT NULL,
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Table structure for `liblog`
-- ----------------------------
DROP TABLE IF EXISTS `liblog`;
CREATE TABLE `liblog` (
  `id` int(10) unsigned NOT NULL,
  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `utime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `wid` int(10) unsigned NOT NULL DEFAULT '0',
  `lid` int(10) unsigned NOT NULL DEFAULT '0',
  `cmd` text NOT NULL,
  `type` int(10) unsigned NOT NULL DEFAULT '0',
  `result` longtext NOT NULL,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `cat` varchar(10) NOT NULL DEFAULT '0',
  `state` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Table structure for `loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog`;
CREATE TABLE `loginlog` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `ip` varchar(40) NOT NULL,
  `state` tinyint(4) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Table structure for `node`
-- ----------------------------
DROP TABLE IF EXISTS `node`;
CREATE TABLE `node` (
  `id` smallint(6) unsigned NOT NULL DEFAULT '0',
  `name` varchar(20) NOT NULL,
  `action` varchar(15) NOT NULL COMMENT '映射为mvc的action',
  `type` varchar(10) NOT NULL COMMENT '子菜单索引使用',
  `ismenu` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否作为菜单显示',
  `title` varchar(50) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `remark` varchar(255) DEFAULT NULL,
  `sort` int(10) unsigned DEFAULT NULL,
  `pid` smallint(6) unsigned NOT NULL,
  `module` char(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `status` (`status`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `node`
-- ----------------------------
BEGIN;
INSERT INTO `node` VALUES ('1002', 'node', 'index', '', '1', '节点管理', '1', '', '20', '1009', 'Rights Management'), ('1003', 'role', 'index', '', '1', '角色管理', '1', '', '0', '1009', 'Rights Management'), ('1004', 'admin-user', 'index', '', '1', '用户管理', '1', '', '10', '1009', 'Rights Management'), ('1162', 'Entity', '', '', '1', '新增实体', '1', 'Entity  ', '200000', '0', ''), ('1009', 'Rights Management', '', '', '1', '权限管理', '1', '大版块', '10000', '0', ''), ('1010', 'General', '', '', '1', '常规', '1', '大版块', '0', '0', ''), ('1163', 'entity', 'index', '', '1', '新增实体页面', '1', '', '0', '1162', 'Entity'), ('1164', 'entity', 'indexSubmit', '', '0', '确认提交', '1', '', '0', '1162', 'Entity'), ('1017', 'index', 'index', '', '1', '后台主页', '1', '', '0', '1010', 'General'), ('1054', 'role', 'auth', '', '0', '角色授权', '1', '', '0', '1009', 'Rights Management'), ('1056', 'node', 'add', '', '0', '新增权限', '1', '', '0', '1009', 'Rights Management'), ('1057', 'node', 'edit', '', '0', '编辑权限', '1', '', '0', '1009', 'Rights Management'), ('1058', 'node', 'del', '', '0', '删除权限', '1', '', '0', '1009', 'Rights Management'), ('1060', 'node', 'aduit', '', '0', '权限(启用/禁用)', '1', '', '0', '1009', 'Rights Management'), ('1072', 'role', 'edit', '', '0', '角色编辑', '1', '', '0', '1009', 'Rights Management'), ('1073', 'role', 'add', '', '0', '添加角色', '1', '', '0', '1009', 'Rights Management'), ('1074', 'role', 'del', '', '0', '删除角色', '1', '', '0', '1009', 'Rights Management'), ('1076', 'admin-user', 'add', '', '0', '添加用户', '1', '', '0', '1009', 'Rights Management'), ('1231', 'highlight', 'index', '', '0', '查看源代码', '1', '', '0', '1236', 'LIB'), ('1084', 'User Info', '', '', '0', '个人信息', '1', '', '0', '0', ''), ('1085', 'userinfo', 'index', '', '0', '查看个人信息', '1', '', '0', '1084', 'User Info'), ('1086', 'userinfo', 'resetpass', '', '0', '重置密码', '1', '', '0', '1084', 'User Info'), ('1087', 'admin-user', 'edit', '', '0', '编辑用户', '1', '', '0', '1009', 'Rights Management'), ('1089', 'admin-user', 'aduit', '', '0', '启用/禁用用户', '1', '', '0', '1009', 'Rights Management'), ('1090', 'admin-user', 'del', '', '0', '删除用户', '1', '', '0', '1009', 'Rights Management'), ('1091', 'role', 'aduit', '', '0', '启用/禁用角色', '1', '', '0', '1009', 'Rights Management'), ('1099', 'Sys Info', '', '', '1', '系统信息', '1', '', '17', '0', ''), ('1100', 'sysinfo', 'index', '', '1', '错误日志', '1', '', '20', '1099', 'Sys Info'), ('1101', 'sysinfo', 'del', '', '0', '删除错误日志', '1', '', '0', '1099', 'Sys Info'), ('1103', 'operationlog', 'del', '', '0', '删除操作日志', '1', '', '0', '1099', 'Sys Info'), ('1104', 'loginlog', 'index', '', '1', '登录日志', '1', '', '10', '1099', 'Sys Info'), ('1105', 'operationlog', 'index', '', '1', '操作日志', '1', '', '0', '1099', 'Sys Info'), ('1232', 'Host', '', '', '1', '主机管理', '1', '大版块', '5000', '0', ''), ('1233', 'website', 'index', '', '1', '项目列表', '1', '', '200', '1246', 'Project'), ('1235', 'lib', 'index', '', '1', '库列表', '1', '', '0', '1236', 'LIB'), ('1236', 'LIB', '', '', '1', '代码库', '1', '', '100', '0', ''), ('1237', 'lib', 'pull', '', '0', '获取指定分支版本代码', '1', '', '0', '1236', 'LIB'), ('1238', 'website', 'add', '', '0', '项目添加', '1', '', '0', '1232', 'Synchronous'), ('1239', 'servergroup', 'index', '', '1', '服务器组列表', '1', '', '201', '1232', 'Synchronous'), ('1240', 'servergroup', 'add', '', '0', '服务器组添加', '1', '', '0', '1232', 'Synchronous'), ('1241', 'server', 'index', '', '1', '服务器列表', '1', '', '202', '1232', 'Synchronous'), ('1242', 'server', 'add', '', '0', '服务器添加', '1', '', '0', '1232', 'Synchronous'), ('1243', 'liblog', 'add', '', '0', 'lib日志添加', '1', '', '0', '1236', 'LIB'), ('1244', 'deployment', 'deploy', '', '1', '项目部署', '1', '', '101', '1246', 'Project'), ('1245', 'liblog', 'index', '', '1', '日志流水', '1', '', '3', '1236', 'LIB'), ('1246', 'Project', '', '', '1', '项目', '1', '', '1', '0', ''), ('1247', 'admin-user', 'web', '', '0', '项目管理授权', '1', '', '100', '1246', 'Project');
COMMIT;

-- ----------------------------
--  Table structure for `operationlog`
-- ----------------------------
DROP TABLE IF EXISTS `operationlog`;
CREATE TABLE `operationlog` (
  `id` int(11) NOT NULL,
  `entity` varchar(15) NOT NULL,
  `pkid` int(11) NOT NULL,
  `desc` text NOT NULL,
  `action` varchar(100) NOT NULL,
  `status` char(1) NOT NULL,
  `uid` int(11) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='操作日志';

-- ----------------------------
--  Records of `operationlog`
-- ----------------------------
BEGIN;
INSERT INTO `operationlog` VALUES ('1454', 'adminuser', '2', 'array (\n  \'passwd\' => \'a8ac3ab02a201627cdee9cfe2b7ffaee\',\n  \'salt\' => \'1wrHM\',\n)', '/userinfo/?action=save', 'Y', '2', '182.18.19.162', '1439377822');
COMMIT;

-- ----------------------------
--  Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` smallint(6) NOT NULL DEFAULT '0',
  `name` varchar(20) NOT NULL,
  `pid` smallint(6) DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `ename` varchar(5) DEFAULT NULL,
  `create_time` int(11) unsigned NOT NULL,
  `update_time` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ename` (`ename`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `role`
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('-500', '超级管理员', '0', '1', '', null, '1407739906', '1407739906'), ('-400', '管理员', '0', '1', '', null, '1434605468', '1434605468');
COMMIT;

-- ----------------------------
--  Table structure for `server`
-- ----------------------------
DROP TABLE IF EXISTS `server`;
CREATE TABLE `server` (
  `id` int(10) unsigned NOT NULL,
  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `utime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sgid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属服务器组',
  `ip` varchar(20) NOT NULL DEFAULT '' COMMENT 'ip',
  `spath` varchar(50) NOT NULL DEFAULT '' COMMENT '同步路径',
  `stype` varchar(20) NOT NULL DEFAULT '' COMMENT '同步工具类型',
  `port` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '端口',
  `sname` varchar(20) NOT NULL DEFAULT '' COMMENT '同步用户',
  `spass` varchar(30) NOT NULL DEFAULT '' COMMENT '同步用户密码',
  `edition` varchar(20) NOT NULL DEFAULT '' COMMENT '当前分支/版本',
  `exclude` text NOT NULL COMMENT '去除的文件',
  `status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `server`
-- ----------------------------
BEGIN;
INSERT INTO `server` VALUES ('22', '2015-08-17 14:10:17', '2015-08-18 11:07:38', '20', '115.29.38.70', '/data/htdocs/crm.wanglibao.com', 'rsync', '22', '-', '-', '', 'a:9:{i:0;s:10:\"src/config\";i:1;s:7:\"project\";i:2;s:12:\"src/autoload\";i:3;s:18:\"src/backstage/data\";i:4;s:3:\"cmd\";i:5;s:4:\".git\";i:6;s:4:\"logs\";i:7;s:3:\"tmp\";i:8;s:9:\"README.md\";}', '1'), ('23', '2015-08-18 13:44:54', '2015-08-18 13:47:02', '21', '115.29.38.70', '/data/htdocs/obs.wanglibao.com', 'rsync', '22', '-', '-', '', 'a:8:{i:0;s:10:\"src/config\";i:1;s:7:\"project\";i:2;s:3:\"cmd\";i:3;s:12:\"src/autoload\";i:4;s:4:\".git\";i:5;s:4:\"logs\";i:6;s:3:\"tmp\";i:7;s:9:\"README.md\";}', '1'), ('24', '2015-08-25 23:09:14', '2015-08-25 23:24:37', '23', '115.29.146.25', '/data/htdocs/ww.mb.com', 'rsync', '22', '-', '-', '', 'a:8:{i:0;s:10:\"src/config\";i:1;s:7:\"project\";i:2;s:3:\"cmd\";i:3;s:12:\"src/autoload\";i:4;s:4:\".git\";i:5;s:4:\"logs\";i:6;s:3:\"tmp\";i:7;s:9:\"README.md\";}', '1'), ('25', '2015-08-25 23:10:00', '2015-08-25 23:19:01', '22', '115.29.146.25', '/data/htdocs/userengine', 'rsync', '22', '-', '-', '', 'a:8:{i:0;s:10:\"src/config\";i:1;s:7:\"project\";i:2;s:3:\"cmd\";i:3;s:12:\"src/autoload\";i:4;s:4:\".git\";i:5;s:4:\"logs\";i:6;s:3:\"tmp\";i:7;s:9:\"README.md\";}', '1');
COMMIT;

-- ----------------------------
--  Table structure for `servergroup`
-- ----------------------------
DROP TABLE IF EXISTS `servergroup`;
CREATE TABLE `servergroup` (
  `id` int(10) unsigned NOT NULL,
  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `utime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sgname` varchar(30) NOT NULL DEFAULT '',
  `wid` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `remark` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Table structure for `sessions`
-- ----------------------------
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `skey` varchar(32) NOT NULL DEFAULT '',
  `expiry` int(11) DEFAULT NULL,
  `value` varchar(5000) DEFAULT NULL,
  PRIMARY KEY (`skey`),
  KEY `sessions_expiry` (`expiry`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

-- ----------------------------
--  Table structure for `sysinfo`
-- ----------------------------
DROP TABLE IF EXISTS `sysinfo`;
CREATE TABLE `sysinfo` (
  `id` int(11) NOT NULL,
  `desc` mediumtext NOT NULL,
  `uptime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='错误提示';

-- ----------------------------
--  Table structure for `website`
-- ----------------------------
DROP TABLE IF EXISTS `website`;
CREATE TABLE `website` (
  `id` int(10) unsigned NOT NULL,
  `ctime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `utime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `wname` varchar(30) NOT NULL DEFAULT '',
  `control` varchar(10) NOT NULL DEFAULT '',
  `cpath` varchar(100) NOT NULL DEFAULT '',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `language` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `website`
-- ----------------------------
BEGIN;
INSERT INTO `website` VALUES ('18', '2015-08-17 14:06:54', '2015-08-17 14:06:54', 'CRM-产品环境', 'GIT', 'https://github.com/licaihuan/crm.git', '2', 'PHP'), ('19', '2015-08-18 12:19:15', '2015-08-18 13:48:45', 'OBS-产品环境', 'GIT', 'https://github.com/licaihuan/obs.git', '2', 'PHP'), ('20', '2015-08-25 22:40:57', '2015-08-25 22:40:57', 'MB-DEMO', 'GIT', 'https://github.com/licaihuan/app.git', '2', 'PHP'), ('21', '2015-08-25 22:41:44', '2015-08-25 22:41:44', 'USERENGIN-DEMO', 'GIT', 'https://github.com/licaihuan/userengine.git', '2', 'PHP');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
